List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.
The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:
develop, store and execute at least three queries, and retrieve and extract data at least three times
perform at least three calculations using control statements, operators and functions
prepare and manipulate at least three tables to meet specific requirements
create and use at least two views and at least two stored procedures according to task requirements.
The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:
information gathering methods that may be used to apply query language in relational databases
industry standard database management systems (DBMS)
methods of connecting to DBMS
using data definition language (DDL), data manipulation language (DML) and data control language (DCL)
data analysis techniques
data mining
data source characteristics
information system features
required systems and procedures that may be used to apply query language in relational databases.
Skills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.
This includes access to:
industry standard software packages
required hardware and its components
a data source
resources in chosen query language
documentation regarding client and functionality requirements
resources to aid calculation.
Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.